USE AdventureWorks2008
GO

SELECT (p.FirstName + ' ' + p.LastName + ' ' + s.Rate)
FROM Person.Person AS p
INNER JOIN HumanResources.EmployeePayHistory AS s
ON p.BusinessEntityID = s.BusinessEntityID

ORDER BY p.BusinessEntityID